Create Street Matrix
Step 1: Select the Matrix Visual
a. Rows = Street, Day of Week, Time by Hour
b. Values = Count of Crimes (rename to Crime Count), Shooting Involved Crimes (rename to Shooter Involved Crimes)
c. Select formatting, in general X position = 11, Y position = 77, Width = 508, Height = 320
d. Column headers, font color = black, background = light gray, font = Constantia, text size = 10
e. Row headers, font color = black, background color = white, font = Constantia, text size = 10
f. Values, font color = black and background color = white, font = Constantia, text size = 10
g. Grand total, color black, font = Constantia, Background = white, text size = 10
h. Conditional formatting, background color on, select advanced controls, format as below.
i. Conditional formatting Shooter Involved Crimes, back ground color on, advanced controls. See below.
j. Border = dark gray, sort the matrix by Crime count descending
Learn how to conditionally format a matrix by viewing the link below.